USE [texchange_db]
GO

/****** Object:  StoredProcedure [dbo].[SP_InsCJCompanyTransport]    Script Date: 05/29/2011 19:47:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE proc [dbo].[SP_InsCJCompanyTransport] 
  @company_id bigint,
  @transporttype_id bigint
as
	BEGIN
		SET NOCOUNT ON

		INSERT INTO CJCompanyTransport (company_id,transporttype_id) 
		VALUES(@company_id, @transporttype_id)
		SELECT NEWID = @@Identity
	END




GO


